In this article, we look at using SQLAlchemy to work with databases and database objects versus using SQL Server Management Studio (SSMS) or other native SQL tools.
In this article, learn how to drop or disable a SQL Server index that is no longer needed. Also, learn how to recreate and script out indexes.
Like regular tables in SQL Server, delta tables in a Microsoft Fabric warehouse also need maintenance which we cover how to automate in this article.
Learn how to generate a PDF file using Azure functions, Python runtime, and the xhtml2pdf package. 
This article includes a PowerShell script that you can run to get a list of your Azure SQL Databases and data such as Server Name, Subscription, Resource Group, Location, Administrator Login, Entra Admin, and CreateDate.
The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.
In this article, we look at how AI tools can generate SQL queries and whether you can rely on the SQL code that is generated.
Learn how to pass parameters to the SQLQueryStress tool to help with SQL Server performance tuning.
Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and we can only see or change its value through XMLA. For example, we can use Tabular Editor for this. We can disable this property in the fields where it will not be needed (and in …
The post Model Optimization: Available In MDX Property appeared first on Simple Talk.
This article looks at the topic of how to calculate modes in T-SQL when working with SQL Server data. 
Learn how to use Spark SQL numeric functions that fall into these three categories: basic, binary, and statistical functions. 
This article will show how to create a SQL Server DDL trigger to capture any DDL commands issued like Create, Alter, Drop, and then send an email notification.
Learn about Snowflake resource monitors to track resource usage. This article covers how to set up, configure, and enable notifications.
Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential. A container is a compact and self-contained package comprising essential components like code, runtime, libraries, and system tools necessary for running an application. Container …
The post Kubernetes For Complete Beginners appeared first on Simple Talk.
In this article, we will dynamically copy data from an on-premises SQL Server to Azure SQL Database using Azure Data Factory and Microsoft Integration Runtime.
Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the previous version they are considered a new feature. The main difference is the possibility to set a target for the result of each query in the dataflow. In this way, it can be used as …
The post 5 Secrets about Dataflows Gen 2 appeared first on Simple Talk.
In this tip, we cover how to fix an SQL Server replication failure caused by duplicate values in a unique index of a replicated table.
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
The need to merge tables when developing Power BI solutions is a fundamental task. In Power BI, DAX offers a powerful function, NATURALINNERJOIN, to streamline this task, making the process of combining data using DAX easier.
Learn about Eventstream in Microsoft Fabric to ingest, transform, and route real-time data.
This article looks at using different statistical calculations when working with Power BI reports and data.
This tip explores a better, more direct, and more optimized method for moving or archiving data in SQL Server using the SQL OUTPUT clause.
In this article, we look at how to manipulate string data in SQL Server using various functions like TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX, and TRANSLATE.